Reconciliation Definition

IMPORTANT: If you have reconciliations that have a frequency other than monthly, upon migration to OneStream Financial Close version PV660 SV100 or later, you must run Discover for all periods where reconciliations exist to ensure that all reconciliations are captured. For example, if you have reconciliations with a quarterly and monthly frequency, run Discover for a quarterly period to ensure that the complete population of inventory is discovered.

The Reconciliation Definition page is where high-level properties are set for all Reconciliation Inventory items that are found through the Discover process. Reconciliation Definitions tell OneStream that these Account dimension members need to be reconciled. Reconciliation Inventory items are detailed Account data rows and Account Groups found in the OneStream Stage that were imported from the General Ledger. This page is not accessible by Local Administrators.

Account List

The initial Account List is generated based on the solution's Recon Account Dimension and Recon Account Member Filter settings in Global Options. These accounts are from the OneStream Cube, not from the General Ledger. This lists each of these accounts along with their account type. If an account has a related Reconciliation Definition, then it displays a value of Reconciled = True.

Reconciliation Definition

Click Discover to add a Reconciliation Definition to each account. Only one Reconciliation Definition can be added per account in the Account List. You can also click the + button to add a Reconciliation Definition to an account.

Reconciled: Determines whether an account is reconciled. If selected, this is set to True in the Account List on the left and the account is reconciled. If cleared, this is set to False in the Account List on the left and it and any of its related detailed imported Stage rows are not reconciled.

Tracking Level: Derived from the Tracking Levels settings page and determines the granularity of the reconciliation. It is used during the Discover process.

Default Template (XLSX): Derived from the Templates page and determines the template used by the preparer. This can be overridden at the Reconciliation Inventory level.

Reference Document: The document to display to the user at run time for this account. See Reference Document Options.

Entity Tracking Level Override

There are times when an account needs to be tracked in the Reconciliation Inventory at a level that is an exception for certain entities beyond the setting for that account in general as set in the Reconciliation Definition. In these cases, click + to add an exception per entity that requires one for this Reconciliation Definition. For instance, account 10000 has a Tracking Level of (Entity), which means by Entity and Account. But for that same account and an entity called ABC, they may need to track this account by Entity, Account and Flow.

Discover

Click Discover to process the Reconciliation Definitions and create the Reconciliation Inventory as a background process. Discover runs for the current and future workflow periods. Prior periods are not affected by the discovery process.

In Global Options, if the Auto Create Recon Definition property is set to Yes, it adds a Reconciliation Definition for each row in the Account List that does not already have one.

This process also builds out the Reconciliation Inventory entries by searching the current and future time periods for the Source Scenario in the Stage for any instance of a row of source data that was mapped to an account that has an active Reconciliation Definition.

IMPORTANT: Clicking Discover searches for every entity associated with the currently selected Workflow Profile, so running Discover at a higher level in the Workflow Profile structure at a Review level Workflow Profile will generate considerably more Reconciliation Definitions.

You can run Discover on multiple workflows simultaneously as long as the workflows do not have a parent/child relationship.  For example, you can run Discover on the Frankfurt and Houston workflows at the same time. But you cannot run Discover on Frankfurt and Clubs at the same time because Clubs is a parent of Frankfurt.

Click the Task Activity icon to show the results of the Discover process and how many new Reconciliation Inventory Items were discovered.

NOTE: You can manually run the Discover process from the Data Management Sequence called DiscoverRecons_RCM. For scheduled Discover jobs, you must pass in these parameters: ProfileKey, SourceScenarioId, ReconScenarioId, TimeKey.

Reference Document Options

A Reference Document is a set of instructions used to explain how to perform a reconciliation. This can be presented to the user as they prepare the reconciliation.

Upload
Load a document to the Reconciliation Definition.

View
Download a copy of the document from the Reconciliation Definition.

Delete
Delete the document from the Reconciliation Definition.